Page 1 of 7
Home Equity Loan Calculator
http://www.vertex42.com/Calculators/home-equity-loan-calculator.html
© 2007 Vertex42, LLC
v 1.1
Inputs
Balance Due at Specified Period
Loan Amount
Annual Interest Rate Term Length (in Years) First Payment Date Compound Period
$
150,000 6.00% 15
1/31/2007
Monthly
Balance at Year … Interest Paid Principal Paid Outstanding Balance
160,000 140,000 120,000
1 $8,826.91 $6,362.57 $143,637.43
No Extra Payments Balance Tax Returned
.
Payment
$1,265.79
Extra Payments (Prepayments) Extra Payment Every N Months Extra Annual Payment Loan Summary Monthly Interest Rate Total Payments Total Interest Number of Payments Last Payment Date Interest Savings Payment Date
1/31/2007 2/28/2007 3/31/2007 4/30/2007 5/31/2007 6/30/2007 7/31/2007 8/31/2007 9/30/2007 10/31/2007 11/30/2007 12/31/2007 1/31/2008 2/29/2008 3/31/2008 4/30/2008 5/31/2008 6/30/2008 7/31/2008 8/31/2008 9/30/2008
100,000
$ $
1 -
80,000 60,000 40,000
20,000
0 Jan-07 Jan-09 Jan-11 Jan-13 Jan-15 Jan-19
$ $
0.500% 227,840.88 77,840.88 180 12/31/2021 (15 years)
Totals Assuming No Extra Payments
Total Payments Total Interest $227,840.88 $77,840.88
$0
Extra Payments
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
No.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Payment
1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79
Additional Payment
Interest
750.00 747.42 744.83 742.22 739.61 736.98 734.33 731.67 729.00 726.32 723.62 720.91 718.19 715.45 712.70 709.93 707.15 704.36 701.55 698.73 695.90
Principal
515.79 518.37 520.96 523.57 526.18 528.81 531.46 534.12 536.79 539.47 542.17 544.88 547.60 550.34 553.09 555.86 558.64 561.43 564.24 567.06 569.89
Balance
$150,000.00 149,484.21 148,965.84 148,444.88 147,921.31 147,395.13 146,866.32 146,334.86 145,800.74 145,263.95 144,724.48 144,182.31 143,637.43 143,089.83 142,539.49 141,986.40 141,430.54 140,871.90 140,310.47 139,746.23 139,179.17 138,609.28
http://www.vertex42.com/Calculators/home-equity-loan-calculator.html
© 2007 Vertex42 LLC
Jan-21
Jan-17
Page 2 of 7
22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73
10/31/2008 11/30/2008 12/31/2008 1/31/2009 2/28/2009 3/31/2009 4/30/2009 5/31/2009 6/30/2009 7/31/2009 8/31/2009 9/30/2009 10/31/2009 11/30/2009 12/31/2009 1/31/2010 2/28/2010 3/31/2010 4/30/2010 5/31/2010 6/30/2010 7/31/2010 8/31/2010 9/30/2010 10/31/2010 11/30/2010 12/31/2010 1/31/2011 2/28/2011 3/31/2011 4/30/2011 5/31/2011 6/30/2011 7/31/2011 8/31/2011 9/30/2011 10/31/2011 11/30/2011 12/31/2011 1/31/2012 2/29/2012 3/31/2012 4/30/2012 5/31/2012 6/30/2012 7/31/2012 8/31/2012 9/30/2012 10/31/2012 11/30/2012 12/31/2012 1/31/2013
1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
693.05 690.18 687.30 684.41 681.51 678.58 675.65 672.70 669.73 666.75 663.76 660.75 657.72 654.68 651.62 648.55 645.47 642.37 639.25 636.12 632.97 629.80 626.62 623.43 620.22 616.99 613.74 610.48 607.21 603.91 600.61 597.28 593.94 590.58 587.20 583.81 580.40 576.97 573.53 570.07 566.59 563.09 559.58 556.05 552.50 548.93 545.35 541.75 538.13 534.49 530.83 527.16
572.74 575.61 578.49 581.38 584.28 587.21 590.14 593.09 596.06 599.04 602.03 605.04 608.07 611.11 614.17 617.24 620.32 623.42 626.54 629.67 632.82 635.99 639.17 642.36 645.57 648.80 652.05 655.31 658.58 661.88 665.18 668.51 671.85 675.21 678.59 681.98 685.39 688.82 692.26 695.72 699.20 702.70 706.21 709.74 713.29 716.86 720.44 724.04 727.66 731.30 734.96 738.63
138,036.54 137,460.93 136,882.44 136,301.06 135,716.78 135,129.57 134,539.43 133,946.34 133,350.28 132,751.24 132,149.21 131,544.17 130,936.10 130,324.99 129,710.82 129,093.58 128,473.26 127,849.84 127,223.30 126,593.63 125,960.81 125,324.82 124,685.65 124,043.29 123,397.72 122,748.92 122,096.87 121,441.56 120,782.98 120,121.10 119,455.92 118,787.41 118,115.56 117,440.35 116,761.76 116,079.78 115,394.39 114,705.57 114,013.31 113,317.59 112,618.39 111,915.69 111,209.48 110,499.74 109,786.45 109,069.59 108,349.15 107,625.11 106,897.45 106,166.15 105,431.19 104,692.56
http://www.vertex42.com/Calculators/home-equity-loan-calculator.html
© 2007 Vertex42 LLC
Page 3 of 7
74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125
2/28/2013 3/31/2013 4/30/2013 5/31/2013 6/30/2013 7/31/2013 8/31/2013 9/30/2013 10/31/2013 11/30/2013 12/31/2013 1/31/2014 2/28/2014 3/31/2014 4/30/2014 5/31/2014 6/30/2014 7/31/2014 8/31/2014 9/30/2014 10/31/2014 11/30/2014 12/31/2014 1/31/2015 2/28/2015 3/31/2015 4/30/2015 5/31/2015 6/30/2015 7/31/2015 8/31/2015 9/30/2015 10/31/2015 11/30/2015 12/31/2015 1/31/2016 2/29/2016 3/31/2016 4/30/2016 5/31/2016 6/30/2016 7/31/2016 8/31/2016 9/30/2016 10/31/2016 11/30/2016 12/31/2016 1/31/2017 2/28/2017 3/31/2017 4/30/2017 5/31/2017
1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
523.46 519.75 516.02 512.27 508.50 504.72 500.91 497.09 493.24 489.38 485.50 481.60 477.68 473.74 469.78 465.80 461.80 457.78 453.74 449.68 445.60 441.50 437.37 433.23 429.07 424.89 420.68 416.46 412.21 407.94 403.65 399.34 395.01 390.65 386.28 381.88 377.46 373.02 368.56 364.07 359.56 355.03 350.48 345.90 341.30 336.68 332.03 327.36 322.67 317.96 313.22 308.45
742.33 746.04 749.77 753.52 757.29 761.07 764.88 768.70 772.55 776.41 780.29 784.19 788.11 792.05 796.01 799.99 803.99 808.01 812.05 816.11 820.19 824.29 828.42 832.56 836.72 840.90 845.11 849.33 853.58 857.85 862.14 866.45 870.78 875.14 879.51 883.91 888.33 892.77 897.23 901.72 906.23 910.76 915.31 919.89 924.49 929.11 933.76 938.43 943.12 947.83 952.57 957.34
103,950.23 103,204.19 102,454.42 101,700.90 100,943.61 100,182.54 99,417.66 98,648.96 97,876.41 97,100.00 96,319.71 95,535.52 94,747.41 93,955.36 93,159.35 92,359.36 91,555.37 90,747.36 89,935.31 89,119.20 88,299.01 87,474.72 86,646.30 85,813.74 84,977.02 84,136.12 83,291.01 82,441.68 81,588.10 80,730.25 79,868.11 79,001.66 78,130.88 77,255.74 76,376.23 75,492.32 74,603.99 73,711.22 72,813.99 71,912.27 71,006.04 70,095.28 69,179.97 68,260.08 67,335.59 66,406.48 65,472.72 64,534.29 63,591.17 62,643.34 61,690.77 60,733.43
http://www.vertex42.com/Calculators/home-equity-loan-calculator.html
© 2007 Vertex42 LLC
Page 4 of 7
126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177
6/30/2017 7/31/2017 8/31/2017 9/30/2017 10/31/2017 11/30/2017 12/31/2017 1/31/2018 2/28/2018 3/31/2018 4/30/2018 5/31/2018 6/30/2018 7/31/2018 8/31/2018 9/30/2018 10/31/2018 11/30/2018 12/31/2018 1/31/2019 2/28/2019 3/31/2019 4/30/2019 5/31/2019 6/30/2019 7/31/2019 8/31/2019 9/30/2019 10/31/2019 11/30/2019 12/31/2019 1/31/2020 2/29/2020 3/31/2020 4/30/2020 5/31/2020 6/30/2020 7/31/2020 8/31/2020 9/30/2020 10/31/2020 11/30/2020 12/31/2020 1/31/2021 2/28/2021 3/31/2021 4/30/2021 5/31/2021 6/30/2021 7/31/2021 8/31/2021 9/30/2021
1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79 1,265.79
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
303.67 298.86 294.02 289.16 284.28 279.37 274.44 269.48 264.50 259.50 254.46 249.41 244.33 239.22 234.09 228.93 223.74 218.53 213.30 208.03 202.74 197.43 192.09 186.72 181.32 175.90 170.45 164.98 159.47 153.94 148.38 142.79 137.18 131.54 125.86 120.16 114.44 108.68 102.89 97.08 91.24 85.36 79.46 73.53 67.57 61.58 55.56 49.50 43.42 37.31 31.17 25.00
962.12 966.93 971.77 976.63 981.51 986.42 991.35 996.31 1,001.29 1,006.29 1,011.33 1,016.38 1,021.46 1,026.57 1,031.70 1,036.86 1,042.05 1,047.26 1,052.49 1,057.76 1,063.05 1,068.36 1,073.70 1,079.07 1,084.47 1,089.89 1,095.34 1,100.81 1,106.32 1,111.85 1,117.41 1,123.00 1,128.61 1,134.25 1,139.93 1,145.63 1,151.35 1,157.11 1,162.90 1,168.71 1,174.55 1,180.43 1,186.33 1,192.26 1,198.22 1,204.21 1,210.23 1,216.29 1,222.37 1,228.48 1,234.62 1,240.79
59,771.31 58,804.38 57,832.61 56,855.98 55,874.47 54,888.05 53,896.70 52,900.39 51,899.10 50,892.81 49,881.48 48,865.10 47,843.64 46,817.07 45,785.37 44,748.51 43,706.46 42,659.20 41,606.71 40,548.95 39,485.90 38,417.54 37,343.84 36,264.77 35,180.30 34,090.41 32,995.07 31,894.26 30,787.94 29,676.09 28,558.68 27,435.68 26,307.07 25,172.82 24,032.89 22,887.26 21,735.91 20,578.80 19,415.90 18,247.19 17,072.64 15,892.21 14,705.88 13,513.62 12,315.40 11,111.19 9,900.96 8,684.67 7,462.30 6,233.82 4,999.20 3,758.41
http://www.vertex42.com/Calculators/home-equity-loan-calculator.html
© 2007 Vertex42 LLC
Page 5 of 7
178 179
10/31/2021 11/30/2021
1,265.79 1,265.79
0.00 0.00
18.79 12.56
1,247.00 1,253.23
2,511.41 1,258.18
http://www.vertex42.com/Calculators/home-equity-loan-calculator.html
© 2007 Vertex42 LLC
Qualification Calculator
Download from Vertex42.com
© 2007 Vertex42, LLC
v 1.1
How Much Money Can I Borrow?
Appraised Value of Home Loan to Value Ratio Maximum Allowable Debt Balance on 1st Mortgage Balance on 2nd Mortgage Balance on other Liens Total Balance Owed
$ $ $ $ $ $
175,000 80.00% 140,000 50,000 10,000 60,000
Potential Loan Amount:
$
80,000
Other considerations affecting how much you can borrow - State laws - Credit history - Income - Other financial obligations Hidden fees - Property appraisal fee - Originator fees - Title fees - Application fee - Closing fees (attorney, filing, etc.) - Early Pay-Off fees
http://www.vertex42.com/Calculators/home-equity-loan-calculator.html
© 2007 Vertex42 LLC
Home Equity Calculator
Download from Vertex42.com
© 2007 Vertex42, LLC
v 1.1.1
Summary Table
Estimate Your Home Equity after N Years
Current Value of Home Yearly Appreciation Rate Balance on 1st Mortgage Annual Interest Rate Monthly Payment (PI) Balance on 2nd Mortgage Annual Interest Rate Monthly Payment (PI) Number of Years from Now
Years 1 2 3 4 5 6 7 8
Balance
142,665 134,746 126,194 116,958 106,981 96,202 84,554 71,965
Equity
10,335 21,314 32,987 45,407 58,631 72,723 87,749 103,784
$
150,000 2.00%
$
100,000 7.00% $ 1,040
11.79 Years to Pay Off
$
50,000 10.00% $ 550 4
14.23 Years to Pay Off (4 years, 0 months)
$160,000 $140,000
$120,000 $100,000 $80,000
Equity
Balance
$60,000
Unpaid Balance: Pre-Tax Home Equity:
Interest Principle Mo. Loan 1 Loan 1
$ 1 2 3 4 5 6 7 8 9 10 11 583.33 580.67 577.99 575.29 572.58 569.86 567.12 564.36 561.58 558.79 555.98 456.67 459.33 462.01 464.71 467.42 470.14 472.88 475.64 478.42 481.21 484.02
$ 116,958 $ 45,407
Interest Principle Loan 2 Loan 2
416.67 415.56 414.44 413.31 412.17 411.02 409.86 408.69 407.51 406.33 405.13 133.33 134.44 135.56 136.69 137.83 138.98 140.14 141.31 142.49 143.67 144.87
$40,000
$20,000 $1 2 3 4 5 6 Years from Now 7 8
Balance Loan 1
100,000 99,543.33 99,084.00 98,621.99 98,157.29 97,689.87 97,219.73 96,746.84 96,271.20 95,792.78 95,311.57 94,827.56
Balance Loan 2
$ 50,000 49,866.67 49,732.22 49,596.66 49,459.96 49,322.13 49,183.15 49,043.01 48,901.70 48,759.21 48,615.54 48,470.67 $
Total Balance
150,000 149,410.00 148,816.23 148,218.65 147,617.25 147,012.00 146,402.88 145,789.85 145,172.90 144,552.00 143,927.11 143,298.23 $
Home Value
150,000 150,247.74 150,495.88 150,744.44 150,993.41 151,242.78 151,492.57 151,742.78 151,993.39 152,244.42 152,495.87 152,747.72 $
Pre-Tax Equity
837.74 1,679.66 2,525.79 3,376.16 4,230.78 5,089.70 5,952.93 6,820.49 7,692.43 8,568.75 9,449.50
http://www.vertex42.com/Calculators/home-equity-loan-calculator.html
© 2007 Vertex42 LLC